Programming Languages | Python
Create layout with Qt creator
Create database using sqlite3
Create functionality with Python PyQt5 and Pycharm
Use database in application
Everything you need for this courese is a basic knowledge of programming, for instance classes, mehods and variables.
This course is not for beginners without any knowledge of programming.
You will learn how to build a professional grade application with Qt creator, Python PyQt5 and sqlite3.
In this course we are going to create layouts with Qt creator, use application functionalities with Python PyQt5 and sqlite3 database.
We will focus on query databases (insert, update and delete), upload and save images to your application, and you will learn how to create statistics as charts. I will show you how to use matplotlib.
For that we generate records from the database and also display them in a table or combo box. You will use sqlite3 DB browse.
After completing this course, you will be able to create your own professional application. Everything will be explained line by line.
At the end of our course I will show you how to create an executable file undependend from Pycharm and your computer.
You will also learn how to use Qt creator to develop professional user interfaces, create menus and menu toolbars. Everything is explained step by step. You will also learn how to set and change text and background colors, and much more.
Let's start! I would be very happy to welcome you as student today!
Lesson- 1: Download and install Qt creator Preview 00:05:33
Lesson- 2: Download and install Pycharm Preview 00:02:27
Lesson- 3: Download and install Python Preview 00:02:29
Lesson- 4: Download and install DB Browser Sqlite3 Preview 00:01:40
Lesson- 5: Car dealer mamagement application Preview 00:05:21
Lesson- 6: How do you work with Pycharm 00:04:51
Lesson- 7: Create Pycharm project 00:05:55
Lesson- 8: Install Python package 00:05:01
Lesson- 9: Create Qt project 00:02:19
Lesson- 10: Create build function 00:05:34
Lesson- 11: Create main function part 1 00:02:47
Lesson- 12: Create main function part 2 00:12:04
Lesson- 13: Style main window 00:05:13
Lesson- 14: Create main window widgets 00:11:23
Lesson- 15: More information 00:06:35
Lesson- 1: Create add new vehicle menu and menu toolbar 00:06:30
Lesson- 2: Create add new vehicle window 00:07:17
Lesson- 3: Create add new vehicle window layout Part1 00:10:03
Lesson- 4: Create add new vehicle window layout part2 00:09:30
Lesson- 5: Create add new vehicle window layout part3 00:08:26
Lesson- 6: Create sqlite3 database 00:10:00
Lesson- 7: Crash course "listen and for loop" in Python 00:14:53
Lesson- 8: Preparing for "Add new vehicle" 00:05:06
Lesson- 9: Create connection function upload picture add new vehicle 00:20:10
Lesson- 10: Create connection function submit add new vehicle part 1 00:10:30
Lesson- 11: Create connection function submit add new vehicle part 2 00:10:57
Lesson- 12: Upload and disply pictures 00:06:27
Lesson- 13: Create overview menu 00:13:36
Lesson- 14: Create display vehicle table layout part1 00:11:49
Lesson- 15: Create display vehicle table layout part2 00:10:14
Lesson- 16: Create display vehicle table layout part3 00:10:42
Lesson- 17: Finish display vehicle table layout 00:04:40
Lesson- 18: Display records from database into table part 1 00:05:57
Lesson- 19: Display records from database into table part 2 00:11:35
Lesson- 20: Display records from database into table part 3 00:08:09
Lesson- 21: QMessageBox type 00:02:45
Lesson- 22: Create connection function search for vehicle part 1 00:11:21
Lesson- 23: Create connection function search for vehicle part 2 00:14:29
Lesson- 24: what's next 00:02:48
Lesson- 25: Create doubleClicked function for tableWidgetDisplyVehicle part1 00:10:00
Lesson- 26: Create show single vehicle widow layout part 1 00:09:05
Lesson- 27: Create show single vehicle widow layout part 2 00:08:09
Lesson- 28: Finish show single vehicle layout 00:12:28
Lesson- 29: What's next 00:05:49
Lesson- 30: Create doubleClicked function for tableWidgetDisplyVehicle part 2 00:10:06
Lesson- 31: Create doubleClicked function for tableWidgetDisplyVehicle part 3 00:16:12
Lesson- 32: Create doubleClicked function for tableWidgetDisplyVehicle part 4 00:03:06
Lesson- 33: Finish doubleClicked function for tableWidgetDisplyVehicle 00:09:52
Lesson- 34: Create connection function update vehicle picture and data part1 00:12:01
Lesson- 35: Finish connection function update vehicle picture and data 00:14:32
Lesson- 36: Create connection function delete vehicle data 00:10:47
Lesson- 37: Create connection function show vehicle status 00:11:00
Lesson- 1: Create add new cars seller window 00:05:15
Lesson- 2: Create connection function menu and menu Toolbar 00:06:53
Lesson- 3: Create add new cars seller window layout part 1 00:06:21
Lesson- 4: Create add new cars seller window layout part 2 00:09:14
Lesson- 5: Finish creat add new cars seller window layout 00:06:53
Lesson- 6: Create seller table 00:07:02
Lesson- 7: More information about Qt creator 00:03:57
Lesson- 8: Create connection function add new seller and picture part 1 00:14:32
Lesson- 9: Finsh connection function add new seller and picture 00:06:50
Lesson- 10: Create show seller menu and table window 00:05:26
Lesson- 11: Create show seller class and menu connection function 00:06:42
Lesson- 12: Create layout show seller table window 00:15:18
Lesson- 13: How do you change your window layout later 00:06:02
Lesson- 14: Change column width seller table 00:07:27
Lesson- 15: Display record from database into seller table 00:12:42
Lesson- 16: Create connection function search for seller and all seller 00:14:22
Lesson- 17: Create show single seller window 00:09:32
Lesson- 18: Create show single seller window layout 00:15:28
Lesson- 19: Create doubleClicked function show single seller part 1. 00:11:30
Lesson- 20: Finish doubleClicked function show single seller 00:12:50
Lesson- 21: Create connection function update seller picture 00:02:22
Lesson- 22: Create connection function update seller data 00:14:31
Lesson- 23: Create connection function delete seller data 00:11:46
Lesson- 1: Create add new customer menu and toolbar 00:12:58
Lesson- 2: Create connection function menu and menu toolbar add new customer 00:12:56
Lesson- 3: Create add new customer window layout 00:12:59
Lesson- 4: Create customer table 00:05:57
Lesson- 5: Create connection function add new customer 00:12:14
Lesson- 6: Create show exsisting customer menu and show customer table window 00:10:12
Lesson- 7: Create show customer table window layout part 1 00:10:01
Lesson- 8: Finish show customer table window layout. 00:06:33
Lesson- 9: Display records from database into customer table 00:12:18
Lesson- 10: Create connection function search for customer and show all customer 00:13:00
Lesson- 11: Create doubleClicked function show single customer part 1 00:10:35
Lesson- 12: Create layout show single customer window part1 00:10:28
Lesson- 13: Finish layout show single customer window 00:03:37
Lesson- 14: Create doubleClicked function show single customer part 2 00:10:18
Lesson- 15: Finish doubleClicked function show single customer 00:09:52
Lesson- 16: Create connection function update customer data 00:14:46
Lesson- 17: Create connection function delete customer data 00:09:06
Lesson- 18: What's next? 00:03:09
Lesson- 1: Create Deal menu and menu toolbar and connection function 00:13:13
Lesson- 2: Create Deal window layout part 1 00:10:01
Lesson- 3: Finish Deal window layout 00:06:06
Lesson- 4: Create sellCars function part 1 00:13:05
Lesson- 5: Create sellCars function part 2 00:07:56
Lesson- 6: Create sellCars function part 3 00:06:52
Lesson- 7: Finish sellCars function 00:10:59
Lesson- 8: Create updateComboPieces connection function 00:15:12
Lesson- 9: Create Deal table 00:04:16
Lesson- 10: Create Make Deal window 00:09:54
Lesson- 11: Create Make Deal window layout part 1 00:09:08
Lesson- 12: Finish Make Deal window layout 00:04:38
Lesson- 13: Preparation submit connection function 00:08:26
Lesson- 14: Create function submit part 1 00:12:43
Lesson- 15: Create function submit part 2 00:11:03
Lesson- 16: Finish function submit 00:09:41
Lesson- 17: Create connection function confirm part 1 00:10:16
Lesson- 18: Create connection function confirm part 2 00:09:53
Lesson- 19: Create connection function confirm part 3 00:11:49
Lesson- 20: Finish connection function confirm 00:12:15
Lesson- 21: What's next? 00:05:38
Lesson- 1: Create menu and menu Toolbar statistic staff per month 00:17:28
Lesson- 2: Create window layout statistic staff per month part 1 00:09:31
Lesson- 3: Finish window layout statistic staff per month 00:07:47
Lesson- 4: Create connection function show overview seller per month part 1 00:14:18
Lesson- 5: Create connection function show overview seller per month part 2 00:10:44
Lesson- 6: Finish connection function show overview seller per month 00:11:27
Lesson- 7: Create menu and menu toolbar statistic staff per year 00:06:31
Lesson- 8: Create connection function menu and menu toolbar statistic staff Year 00:10:26
Lesson- 9: Create window layout statistic staff per year part 1 00:09:09
Lesson- 10: Finish window layout statistic staff per year 00:05:33
Lesson- 11: Create connection function show overview seller per year part 1 00:14:26
Lesson- 12: Finish connection function show overview seller per year 00:16:12
Lesson- 13: Create menu and menu toolbar statistic customer per year 00:14:00
Lesson- 14: Create window layout statistic customer year part 1 00:09:25
Lesson- 15: Finish window layout statistic customer year. 00:04:44
Lesson- 16: Create connection function statistic customer per year part 1 00:11:43
Lesson- 17: Create connection function statistic customer per year part 2 00:09:22
Lesson- 18: Finish connection function statistic customer per year 00:10:56
Lesson- 19: Create menu and menu Toolbar monthly overview 00:14:41
Lesson- 20: Create window layout monthly overview part 1 00:07:43
Lesson- 21: Finish window layout monthly overview 00:05:45
Lesson- 22: Create connection function show monthly overview part 1 00:12:13
Lesson- 23: Finish connection function show monthly overview 00:12:33
Lesson- 24: Create menu and menu toolbar annual overview 00:13:02
Lesson- 25: Create window layout annual overview 00:10:04
Lesson- 26: Create connection function annual overview part 1 00:07:50
Lesson- 27: Finish connection function annual overview 00:18:06
Lesson- 1: Example data chart 00:06:37
Lesson- 2: Create graphic function for statistic staff per month part 1 00:13:09
Lesson- 3: Finish graphic function for statistic staff per month 00:08:06
Lesson- 4: Create an executable file from our application 00:04:27
Lesson- 5: Course icons 00:05:00
Lesson- 6: course Pictures 00:05:00
Lesson- 7: Course Code 00:05:00
Lesson- 8: Course Code Bild 00:05:00
We can send you everything you need to know about this course through email.
We respect your privacy. your information is safe and will never be shared.